package com.ruoyi.system.service;

import java.util.List;
import java.util.Map;

import com.ruoyi.system.domain.SysCgImportMain;

/**
 * SysCgImportMainService接口
 * 
 * @author SYF
 * @date 2025-05-08
 */
public interface ISysCgImportMainService 
{

    /**
     * 查询SysCgImportMain列表
     * 
     * @param sysCgImportMain SysCgImportMain
     * @return SysCgImportMain集合
     */
    public List<SysCgImportMain> selectSysCgImportMainList(SysCgImportMain sysCgImportMain);

    public List<SysCgImportMain> selectSysCgImportMainUnLinkList(SysCgImportMain sysCgImportMain);

    /**
     * 新增SysCgImportMain
     * 
     * @param sysCgImportMain SysCgImportMain
     * @return 结果
     */
    public int insertSysCgImportMain(SysCgImportMain sysCgImportMain);

    /**
     * 修改SysCgImportMain
     * 
     * @param sysCgImportMain SysCgImportMain
     * @return 结果
     */
    public int updateSysCgImportMain(SysCgImportMain sysCgImportMain);

    public List<Map<String,Object>> selectDepts(String year);

    public List<Map<String,Object>> selectSales(String year);

    public List<Map<String,Object>> selectTypes(String year);

    public List<SysCgImportMain> selectCgImportMainList(SysCgImportMain sysCgImportMain);

    public List<Map<String,Object>> selectSpecs(String startDate,String endDate);

    public List<Map<String,Object>> selectCustomers(String startDate,String endDate);

    public List<Map<String,Object>> selectUnSupplyList();

    public List<Map<String,Object>> selectResampleList();

    public List<Map<String,Object>> selectUnfulfilledList(String year);

    public List<Map<String,Object>> selectInventoryList(String year);

    public List<Map<String,Object>> selectInventoryListNew();

    public List<Map<String,Object>> selectInventoryDetail(String year);

    public Map<String,Object> selectLatestDate();

    public List<Map<String,Object>> excuteQuery(String sql);
}
